[dbo].[BAEConfigurationInsert]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@ConfigurationID	int	4
@Variable	varchar(256)	256
@CurrentValue	varchar(4096)	4096
@DefaultValue	varchar(4096)	4096
@Description	varchar(1024)	1024
@Category	varchar(256)	256

SQL Script

create procedure [dbo].[BAEConfigurationInsert] @ConfigurationID as
int,
    @Variable AS varchar(256),
    @CurrentValue AS varchar(4096),
    @DefaultValue AS varchar(4096),
    @Description AS varchar(1024),
    @Category AS varchar(256)
AS
    INSERT INTO Configuration
    (
    Variable,
    CurrentValue,
    DefaultValue,
    Description,
    Category
    )
    VALUES
    (
    @Variable,
    @CurrentValue,
    @DefaultValue,
    @Description,
    @Category
    );

SELECT CAST(@@IDENTITY AS int) AS "InsertedConfiguration";

GO